Overview

Dataset info

Number of variables52
Number of observations85274
Missing cells317726 (7.2%)
Duplicate rows0 (0.0%)
Total size in memory33.8 MiB
Average record size in memory416.0 B

Variables types

Numeric21
Categorical23
Boolean5
Date0
URL0
Text (Unique)0
Rejected0
Unsupported3

Warnings

amenities has a high cardinality: 74990 distinct values Warning
availability_365 has 28859 (33.8%) zeros Zeros
bedrooms has 5145 (6.0%) zeros Zeros
beds has 2091 (2.5%) zeros Zeros
city has a high cardinality: 699 distinct values Warning
cleaning_fee has a high cardinality: 260 distinct values Warning
cleaning_fee has 21530 (25.2%) missing values Missing
extra_people has a high cardinality: 115 distinct values Warning
first_review has a high cardinality: 2759 distinct values Warning
first_review has 21005 (24.6%) missing values Missing
host_neighbourhood has a high cardinality: 450 distinct values Warning
host_neighbourhood has 18862 (22.1%) missing values Missing
host_response_rate has a high cardinality: 79 distinct values Warning
host_response_rate has 24822 (29.1%) missing values Missing
host_since has a high cardinality: 3419 distinct values Warning
host_total_listings_count is an unsupported type, check if it needs cleaning or further analysis Warning
host_verifications has a high cardinality: 549 distinct values Warning
last_review has a high cardinality: 1779 distinct values Warning
last_review has 21005 (24.6%) missing values Missing
latitude is highly skewed (γ1 = -240.8585945) Skewed
maximum_nights is highly skewed (γ1 = 229.4519732) Skewed
maximum_nights_avg_ntm is an unsupported type, check if it needs cleaning or further analysis Warning
minimum_nights is highly skewed (γ1 = 31.59675247) Skewed
minimum_nights_avg_ntm is an unsupported type, check if it needs cleaning or further analysis Warning
neighbourhood has a high cardinality: 150 distinct values Warning
number_of_reviews has 21003 (24.6%) zeros Zeros
number_of_reviews_ltm has 35468 (41.6%) zeros Zeros
price has a high cardinality: 889 distinct values Warning
review_scores_accuracy has 22735 (26.7%) missing values Missing
review_scores_checkin has 22783 (26.7%) missing values Missing
review_scores_cleanliness has 22722 (26.6%) missing values Missing
review_scores_communication has 22728 (26.7%) missing values Missing
review_scores_location has 22782 (26.7%) missing values Missing
review_scores_rating has 22684 (26.6%) missing values Missing
review_scores_value has 22783 (26.7%) missing values Missing
reviews_per_month has 21005 (24.6%) missing values Missing
security_deposit has a high cardinality: 381 distinct values Warning
security_deposit has 29653 (34.8%) missing values Missing

Variables

accommodates
Numeric

Distinct count20
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean3.203370352
Minimum0
Maximum30
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q12
Median2
Q34
95-th percentile7
Maximum30
Range30
Interquartile range2

Descriptive statistics

Standard deviation2.02480499
Coef of variation0.6320858246
Kurtosis4.67517003
Mean3.203370352
MAD1.585952343
Skewness1.705313746
Sum273161
Variance4.099835249
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%) 
2 35777 42.0%
 
4 17026 20.0%
 
1 10608 12.4%
 
6 6899 8.1%
 
3 5851 6.9%
 
5 4033 4.7%
 
8 2106 2.5%
 
7 1374 1.6%
 
10 569 0.7%
 
9 448 0.5%
 
Other values (9) 582 0.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
1 10608 12.4%
 
2 35777 42.0%
 
3 5851 6.9%
 
4 17026 20.0%
 

Maximum 5 values

ValueCountFrequency (%) 
30 1 < 0.1%
 
20 1 < 0.1%
 
16 101 0.1%
 
15 24 < 0.1%
 
14 90 0.1%
 

amenities
Categorical

Distinct count74990
Unique (%)87.9%
Missing (%)< 0.1%
Missing (n)1
{}
 
350
{Wifi,Kitchen,Heating,Washer,Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hot water","Bed linens"}
 
71
{TV,Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,Iron}
 
58
Other values (74986)
84794
ValueCountFrequency (%) 
{} 350 0.4%
 
{Wifi,Kitchen,Heating,Washer,Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hot water","Bed linens"} 71 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,Iron} 58 0.1%
 
{Wifi,Kitchen,Elevator,Heating,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Hot water","Bed linens","Extra pillows and blankets",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed","Well-lit path to entrance"} 55 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} 54 0.1%
 
{TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Heating,"Suitable for events",Washer,Dryer,"Smoke detector","First aid kit",Essentials,"Hair dryer"} 52 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} 45 0.1%
 
{TV,"Cable TV",Wifi,"Air conditioning",Elevator,Heating,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Keypad,"Private living room","Hot water","Bed linens","Long term stays allowed"} 43 0.1%
 
{TV,Wifi,Kitchen,Elevator,"Family/kid friendly",Washer,Essentials,Hangers,"Laptop friendly workspace","Private living room",Microwave,Dishwasher,Oven} 33 < 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} 31 < 0.1%
 
Other values (74979) 84481 99.1%
 
Max length1546
Mean length279.3763046
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

availability_365
Numeric

Distinct count367
Unique (%)0.4%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean118.7482204
Minimum0
Maximum365
Zeros (%)33.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median61
Q3252
95-th percentile362
Maximum365
Range365
Interquartile range252

Descriptive statistics

Standard deviation134.7225959
Coef of variation1.134523072
Kurtosis-1.085641577
Mean118.7482204
MAD119.0340653
Skewness0.7226974104
Sum10126017
Variance18150.17783
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 28859 33.8%
 
365 2177 2.6%
 
364 1272 1.5%
 
1 845 1.0%
 
89 680 0.8%
 
90 673 0.8%
 
363 625 0.7%
 
257 578 0.7%
 
179 510 0.6%
 
2 498 0.6%
 
Other values (356) 48556 56.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 28859 33.8%
 
1 845 1.0%
 
2 498 0.6%
 
3 492 0.6%
 
4 413 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
365 2177 2.6%
 
364 1272 1.5%
 
363 625 0.7%
 
362 348 0.4%
 
361 227 0.3%
 

bathrooms
Numeric

Distinct count25
Unique (%)< 0.1%
Missing (%)0.2%
Missing (n)128
Infinite (%)0.0%
Infinite (n)0
Mean1.305639725
Minimum0
Maximum17
Zeros (%)0.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
Median1
Q31.5
95-th percentile2.5
Maximum17
Range17
Interquartile range0.5

Descriptive statistics

Standard deviation0.614785734
Coef of variation0.4708693542
Kurtosis29.11778953
Mean1.305639725
MAD0.4410605119
Skewness3.553140723
Sum111170
Variance0.3779614987
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%) 
1 59361 69.6%
 
2 12306 14.4%
 
1.5 7879 9.2%
 
2.5 2426 2.8%
 
3 1436 1.7%
 
3.5 554 0.6%
 
0.5 301 0.4%
 
0 300 0.4%
 
4 264 0.3%
 
4.5 114 0.1%
 
Other values (14) 205 0.2%
 
(Missing) 128 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 300 0.4%
 
0.5 301 0.4%
 
1 59361 69.6%
 
1.5 7879 9.2%
 
2 12306 14.4%
 

Maximum 5 values

ValueCountFrequency (%) 
17 1 < 0.1%
 
11 1 < 0.1%
 
10.5 1 < 0.1%
 
10 23 < 0.1%
 
9.5 1 < 0.1%
 

bed_type
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Real Bed
84575
Pull-out Sofa
 
409
Futon
 
180
Other values (3)
 
109
ValueCountFrequency (%) 
Real Bed 84575 99.2%
 
Pull-out Sofa 409 0.5%
 
Futon 180 0.2%
 
Couch 66 0.1%
 
Airbed 42 < 0.1%
 
2019-09-15 1 < 0.1%
 
(Missing) 1 < 0.1%
 
Max length13
Mean length8.014306823
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

bedrooms
Numeric

Distinct count16
Unique (%)< 0.1%
Missing (%)0.1%
Missing (n)43
Infinite (%)0.0%
Infinite (n)0
Mean1.417442011
Minimum0
Maximum22
Zeros (%)6.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median1
Q32
95-th percentile3
Maximum22
Range22
Interquartile range1

Descriptive statistics

Standard deviation0.9227134453
Coef of variation0.6509708605
Kurtosis8.914784896
Mean1.417442011
MAD0.692721928
Skewness1.962128378
Sum120810
Variance0.8514001022
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%) 
1 53248 62.4%
 
2 17616 20.7%
 
3 5952 7.0%
 
0 5145 6.0%
 
4 2289 2.7%
 
5 722 0.8%
 
6 182 0.2%
 
7 49 0.1%
 
8 12 < 0.1%
 
10 6 < 0.1%
 
Other values (5) 10 < 0.1%
 
(Missing) 43 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5145 6.0%
 
1 53248 62.4%
 
2 17616 20.7%
 
3 5952 7.0%
 
4 2289 2.7%
 

Maximum 5 values

ValueCountFrequency (%) 
22 1 < 0.1%
 
16 1 < 0.1%
 
12 1 < 0.1%
 
11 2 < 0.1%
 
10 6 < 0.1%
 

beds
Numeric

Distinct count23
Unique (%)< 0.1%
Missing (%)0.2%
Missing (n)154
Infinite (%)0.0%
Infinite (n)0
Mean1.75587406
Minimum0
Maximum28
Zeros (%)2.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
Median1
Q32
95-th percentile4
Maximum28
Range28
Interquartile range1

Descriptive statistics

Standard deviation1.278724005
Coef of variation0.7282549666
Kurtosis16.2053685
Mean1.75587406
MAD0.9116902133
Skewness2.798323325
Sum149460
Variance1.635135081
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%) 
1 46476 54.5%
 
2 20662 24.2%
 
3 8667 10.2%
 
4 3998 4.7%
 
0 2091 2.5%
 
5 1623 1.9%
 
6 842 1.0%
 
7 325 0.4%
 
8 201 0.2%
 
10 75 0.1%
 
Other values (12) 160 0.2%
 
(Missing) 154 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2091 2.5%
 
1 46476 54.5%
 
2 20662 24.2%
 
3 8667 10.2%
 
4 3998 4.7%
 

Maximum 5 values

ValueCountFrequency (%) 
28 1 < 0.1%
 
20 3 < 0.1%
 
19 2 < 0.1%
 
18 2 < 0.1%
 
17 2 < 0.1%
 

calculated_host_listings_count
Numeric

Distinct count86
Unique (%)0.1%
Missing (%)< 0.1%
Missing (n)2
Infinite (%)0.0%
Infinite (n)0
Mean24.93245145
Minimum1
Maximum1130
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q35
95-th percentile65
Maximum1130
Range1129
Interquartile range4

Descriptive statistics

Standard deviation131.0934511
Coef of variation5.257944706
Kurtosis63.96747936
Mean24.93245145
MAD38.95463532
Skewness7.971575249
Sum2126040
Variance17185.49292
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 43850 51.4%
 
2 12034 14.1%
 
3 4968 5.8%
 
4 2924 3.4%
 
5 1795 2.1%
 
6 1422 1.7%
 
7 1148 1.3%
 
1130 1130 1.3%
 
8 832 1.0%
 
9 729 0.9%
 
Other values (75) 14440 16.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 43850 51.4%
 
2 12034 14.1%
 
3 4968 5.8%
 
4 2924 3.4%
 
5 1795 2.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1130 1130 1.3%
 
227 227 0.3%
 
220 220 0.3%
 
196 196 0.2%
 
189 189 0.2%
 

cancellation_policy
Categorical

Distinct count9
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)2
strict_14_with_grace_period
36612
flexible
27738
moderate
20052
Other values (5)
 
870
ValueCountFrequency (%) 
strict_14_with_grace_period 36612 42.9%
 
flexible 27738 32.5%
 
moderate 20052 23.5%
 
super_strict_60 473 0.6%
 
super_strict_30 366 0.4%
 
luxury_moderate 20 < 0.1%
 
strict 8 < 0.1%
 
luxury_super_strict_95 3 < 0.1%
 
(Missing) 2 < 0.1%
 
Max length27
Mean length16.22826418
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

city
Categorical

Distinct count699
Unique (%)0.8%
Missing (%)0.2%
Missing (n)179
Greater London
46521
London
33099
London
 
557
Other values (695)
 
4918
(Missing)
 
179
ValueCountFrequency (%) 
Greater London 46521 54.6%
 
London 33099 38.8%
 
London 557 0.7%
 
Richmond 177 0.2%
 
Twickenham 174 0.2%
 
Croydon 161 0.2%
 
Londres 152 0.2%
 
Kingston upon Thames 125 0.1%
 
Ilford 124 0.1%
 
Harrow 119 0.1%
 
Other values (688) 3886 4.6%
 
(Missing) 179 0.2%
 
Max length48
Mean length10.57735066
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

cleaning_fee
Categorical

Distinct count260
Unique (%)0.3%
Missing (%)25.2%
Missing (n)21530
$0.00
 
5938
$20.00
 
5240
$30.00
 
5104
Other values (256)
47462
(Missing)
21530
ValueCountFrequency (%) 
$0.00 5938 7.0%
 
$20.00 5240 6.1%
 
$30.00 5104 6.0%
 
$10.00 4549 5.3%
 
$50.00 3880 4.6%
 
$15.00 3689 4.3%
 
$40.00 3677 4.3%
 
$25.00 3271 3.8%
 
$60.00 2506 2.9%
 
$35.00 1961 2.3%
 
Other values (249) 23929 28.1%
 
(Missing) 21530 25.2%
 
Max length9
Mean length5.198290217
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

experiences_offered
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
none
83540
business
 
598
family
 
493
Other values (3)
 
643
ValueCountFrequency (%) 
none 83540 98.0%
 
business 598 0.7%
 
family 493 0.6%
 
social 426 0.5%
 
romantic 216 0.3%
 
1.0 1 < 0.1%
 
Max length8
Mean length4.059725121
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

extra_people
Categorical

Distinct count115
Unique (%)0.1%
Missing (%)< 0.1%
Missing (n)1
$0.00
52172
$10.00
 
7915
$15.00
 
6516
Other values (111)
18670
ValueCountFrequency (%) 
$0.00 52172 61.2%
 
$10.00 7915 9.3%
 
$15.00 6516 7.6%
 
$20.00 4851 5.7%
 
$25.00 2285 2.7%
 
$5.00 2270 2.7%
 
$30.00 1698 2.0%
 
$50.00 1072 1.3%
 
$12.00 662 0.8%
 
$35.00 641 0.8%
 
Other values (104) 5191 6.1%
 
Max length7
Mean length5.344841335
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

first_review
Categorical

Distinct count2759
Unique (%)3.2%
Missing (%)24.6%
Missing (n)21005
2019-07-07
 
234
2019-01-01
 
222
2019-07-14
 
199
Other values (2755)
63614
(Missing)
21005
ValueCountFrequency (%) 
2019-07-07 234 0.3%
 
2019-01-01 222 0.3%
 
2019-07-14 199 0.2%
 
2019-06-30 196 0.2%
 
2019-06-02 185 0.2%
 
2019-08-11 176 0.2%
 
2019-01-02 170 0.2%
 
2019-08-04 162 0.2%
 
2019-04-28 162 0.2%
 
2018-01-01 161 0.2%
 
Other values (2748) 62402 73.2%
 
(Missing) 21005 24.6%
 
Max length10
Mean length8.275734691
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

guests_included
Numeric

Distinct count17
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean1.615200591
Minimum1
Maximum16
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile4
Maximum16
Range15
Interquartile range1

Descriptive statistics

Standard deviation1.356016781
Coef of variation0.8395345994
Kurtosis15.30142629
Mean1.615200591
MAD0.8886799902
Skewness3.306687154
Sum137733
Variance1.838781511
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%) 
1 61590 72.2%
 
2 12953 15.2%
 
4 5594 6.6%
 
3 1622 1.9%
 
6 1595 1.9%
 
5 874 1.0%
 
8 469 0.5%
 
7 251 0.3%
 
10 138 0.2%
 
9 75 0.1%
 
Other values (6) 112 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 61590 72.2%
 
2 12953 15.2%
 
3 1622 1.9%
 
4 5594 6.6%
 
5 874 1.0%
 

Maximum 5 values

ValueCountFrequency (%) 
16 30 < 0.1%
 
15 12 < 0.1%
 
14 6 < 0.1%
 
13 5 < 0.1%
 
12 33 < 0.1%
 

host_has_profile_pic
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)18
t
85026
f
 
230
(Missing)
 
18
ValueCountFrequency (%) 
t 85026 99.7%
 
f 230 0.3%
 
(Missing) 18 < 0.1%
 

host_identity_verified
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)17
f
54698
t
30558
$109.00
 
1
(Missing)
 
17
ValueCountFrequency (%) 
f 54698 64.1%
 
t 30558 35.8%
 
$109.00 1 < 0.1%
 
(Missing) 17 < 0.1%
 
Max length7
Mean length1.000469076
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

host_is_superhost
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)17
f
72741
t
 
12515
Entire home/apt
 
1
(Missing)
 
17
ValueCountFrequency (%) 
f 72741 85.3%
 
t 12515 14.7%
 
Entire home/apt 1 < 0.1%
 
(Missing) 17 < 0.1%
 
Max length15
Mean length1.000562891
Min length1
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

host_neighbourhood
Categorical

Distinct count450
Unique (%)0.5%
Missing (%)22.1%
Missing (n)18862
LB of Brent
 
1770
LB of Islington
 
1764
Shoreditch
 
1723
Other values (446)
61155
(Missing)
18862
ValueCountFrequency (%) 
LB of Brent 1770 2.1%
 
LB of Islington 1764 2.1%
 
Shoreditch 1723 2.0%
 
Hampstead 1569 1.8%
 
Hammersmith 1523 1.8%
 
LB of Haringey 1509 1.8%
 
Battersea 1405 1.6%
 
Whitechapel/Brick Lane 1364 1.6%
 
Earls Court 1351 1.6%
 
Sands End 1284 1.5%
 
Other values (439) 51150 60.0%
 
(Missing) 18862 22.1%
 
Max length33
Mean length9.525283205
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

host_response_rate
Categorical

Distinct count79
Unique (%)0.1%
Missing (%)29.1%
Missing (n)24822
100%
40283
98%
 
2529
90%
 
2055
Other values (75)
15585
(Missing)
24822
ValueCountFrequency (%) 
100% 40283 47.2%
 
98% 2529 3.0%
 
90% 2055 2.4%
 
99% 1727 2.0%
 
80% 1182 1.4%
 
0% 1123 1.3%
 
94% 890 1.0%
 
97% 886 1.0%
 
50% 789 0.9%
 
95% 698 0.8%
 
Other values (68) 8290 9.7%
 
(Missing) 24822 29.1%
 
Max length4
Mean length3.459166921
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

host_since
Categorical

Distinct count3419
Unique (%)4.0%
Missing (%)< 0.1%
Missing (n)16
2015-05-21
 
1164
2017-10-25
 
297
2015-03-05
 
266
Other values (3415)
83531
ValueCountFrequency (%) 
2015-05-21 1164 1.4%
 
2017-10-25 297 0.3%
 
2015-03-05 266 0.3%
 
2017-06-26 264 0.3%
 
2015-11-04 251 0.3%
 
2018-11-08 202 0.2%
 
2011-11-22 177 0.2%
 
2012-03-18 168 0.2%
 
2014-03-26 167 0.2%
 
2015-02-11 160 0.2%
 
Other values (3408) 82142 96.3%
 
Max length10
Mean length9.998592772
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

host_total_listings_count
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

host_verifications
Categorical

Distinct count549
Unique (%)0.6%
Missing (%)< 0.1%
Missing (n)1
['email', 'phone', 'reviews', 'jumio', 'government_id']
 
9938
['email', 'phone']
 
8952
['email', 'phone', 'reviews']
 
6623
Other values (545)
59760
ValueCountFrequency (%) 
['email', 'phone', 'reviews', 'jumio', 'government_id'] 9938 11.7%
 
['email', 'phone'] 8952 10.5%
 
['email', 'phone', 'reviews'] 6623 7.8%
 
['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] 6250 7.3%
 
['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id'] 5077 6.0%
 
['email', 'phone', 'reviews', 'jumio', 'government_id', 'work_email'] 3384 4.0%
 
['email', 'phone', 'facebook', 'reviews', 'jumio', 'government_id'] 3347 3.9%
 
['email', 'phone', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] 2823 3.3%
 
['email', 'phone', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] 2741 3.2%
 
['phone'] 2460 2.9%
 
Other values (538) 33678 39.5%
 
Max length371
Mean length66.24819992
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

instant_bookable
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)2
f
48092
t
37180
(Missing)
 
2
ValueCountFrequency (%) 
f 48092 56.4%
 
t 37180 43.6%
 
(Missing) 2 < 0.1%
 

is_business_travel_ready
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)2
f
85272
(Missing)
 
2
ValueCountFrequency (%) 
f 85272 > 99.9%
 
(Missing) 2 < 0.1%
 
Max length3
Mean length1.000046908
Min length1
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

is_location_exact
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
t
52899
f
32373
15.0
 
1
(Missing)
 
1
ValueCountFrequency (%) 
t 52899 62.0%
 
f 32373 38.0%
 
15.0 1 < 0.1%
 
(Missing) 1 < 0.1%
 
Max length4
Mean length1.000058635
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

last_review
Categorical

Distinct count1779
Unique (%)2.1%
Missing (%)24.6%
Missing (n)21005
2019-08-26
 
1312
2019-09-01
 
1258
2019-09-08
 
1148
Other values (1775)
60551
(Missing)
21005
ValueCountFrequency (%) 
2019-08-26 1312 1.5%
 
2019-09-01 1258 1.5%
 
2019-09-08 1148 1.3%
 
2019-08-25 1137 1.3%
 
2019-08-27 1086 1.3%
 
2019-08-31 1070 1.3%
 
2019-08-30 969 1.1%
 
2019-08-18 954 1.1%
 
2019-09-12 849 1.0%
 
2019-08-29 780 0.9%
 
Other values (1768) 53706 63.0%
 
(Missing) 21005 24.6%
 
Max length10
Mean length8.275734691
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

latitude
Numeric

Distinct count20696
Unique (%)24.3%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean51.50928881
Minimum15
Maximum51.68169
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum15
5-th percentile51.4253
Q151.48551
Median51.51403
Q351.53747
95-th percentile51.58418
Maximum51.68169
Range36.68169
Interquartile range0.05196

Descriptive statistics

Standard deviation0.1333188052
Coef of variation0.002588247834
Kurtosis65955.7366
Mean51.50928881
MAD0.03554810058
Skewness-240.8585945
Sum4392351.585
Variance0.01777390381
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
51.51571 27 < 0.1%
 
51.51375 24 < 0.1%
 
51.52559 23 < 0.1%
 
51.51382 22 < 0.1%
 
51.52476 22 < 0.1%
 
51.51333 21 < 0.1%
 
51.49133 21 < 0.1%
 
51.51516 21 < 0.1%
 
51.52486 21 < 0.1%
 
51.51459 21 < 0.1%
 
Other values (20685) 85050 99.7%
 

Minimum 5 values

ValueCountFrequency (%) 
15 1 < 0.1%
 
51.29479 1 < 0.1%
 
51.29733 1 < 0.1%
 
51.29893 1 < 0.1%
 
51.29911 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
51.68169 1 < 0.1%
 
51.6792 1 < 0.1%
 
51.67651 1 < 0.1%
 
51.67566 1 < 0.1%
 
51.67501 1 < 0.1%
 

longitude
Numeric

Distinct count32025
Unique (%)37.6%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean-0.1279193362
Minimum-0.50916
Maximum2
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-0.50916
5-th percentile-0.28205
Q1-0.18799
Median-0.12592
Q3-0.06998
95-th percentile0.01455
Maximum2
Range2.50916
Interquartile range0.11801

Descriptive statistics

Standard deviation0.09266576177
Coef of variation-0.7244077752
Kurtosis4.425238226
Mean-0.1279193362
MAD0.07103071814
Skewness0.02414535358
Sum-10908.06556
Variance0.008586943405
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
-0.07057 14 < 0.1%
 
-0.19517 13 < 0.1%
 
-0.13745 13 < 0.1%
 
-0.13649 13 < 0.1%
 
-0.0718 13 < 0.1%
 
-0.09728 13 < 0.1%
 
-0.1404 12 < 0.1%
 
-0.09945 12 < 0.1%
 
-0.14027 12 < 0.1%
 
-0.07015 12 < 0.1%
 
Other values (32014) 85146 99.8%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.50916 1 < 0.1%
 
-0.5013 1 < 0.1%
 
-0.49625 1 < 0.1%
 
-0.49582 1 < 0.1%
 
-0.48786 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2 1 < 0.1%
 
0.28774 1 < 0.1%
 
0.28539 1 < 0.1%
 
0.28429 1 < 0.1%
 
0.27268 1 < 0.1%
 

maximum_nights
Numeric

Distinct count311
Unique (%)0.4%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean20127.48501
Minimum1
Maximum999999999
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile7
Q131
Median1125
Q31125
95-th percentile1125
Maximum999999999
Range999999998
Interquartile range1094

Descriptive statistics

Standard deviation3883024.443
Coef of variation192.9214923
Kurtosis55499.53744
Mean20127.48501
MAD38812.30338
Skewness229.4519732
Sum1716331029
Variance1.507787883e+13
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1125 50694 59.4%
 
30 4580 5.4%
 
14 3115 3.7%
 
7 2389 2.8%
 
90 2336 2.7%
 
365 1629 1.9%
 
60 1503 1.8%
 
10 1398 1.6%
 
21 1211 1.4%
 
1124 1142 1.3%
 
Other values (300) 15276 17.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 149 0.2%
 
2 313 0.4%
 
3 576 0.7%
 
4 617 0.7%
 
5 918 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
999999999 1 < 0.1%
 
524855552 1 < 0.1%
 
99999999 1 < 0.1%
 
10000000 1 < 0.1%
 
9999999 1 < 0.1%
 

maximum_nights_avg_ntm
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

minimum_nights
Numeric

Distinct count110
Unique (%)0.1%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean4.120471896
Minimum1
Maximum1125
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q33
95-th percentile7
Maximum1125
Range1124
Interquartile range2

Descriptive statistics

Standard deviation15.65278504
Coef of variation3.798784565
Kurtosis1754.615821
Mean4.120471896
MAD3.72864413
Skewness31.59675247
Sum351365
Variance245.0096795
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 28511 33.4%
 
2 25480 29.9%
 
3 13779 16.2%
 
4 4482 5.3%
 
5 4334 5.1%
 
7 3525 4.1%
 
6 1041 1.2%
 
14 804 0.9%
 
10 536 0.6%
 
30 490 0.6%
 
Other values (99) 2291 2.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 28511 33.4%
 
2 25480 29.9%
 
3 13779 16.2%
 
4 4482 5.3%
 
5 4334 5.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1125 1 < 0.1%
 
1124 2 < 0.1%
 
1000 2 < 0.1%
 
999 1 < 0.1%
 
900 1 < 0.1%
 

minimum_nights_avg_ntm
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

neighbourhood
Categorical

Distinct count150
Unique (%)0.2%
Missing (%)< 0.1%
Missing (n)2
City of Westminster
 
5583
LB of Tower Hamlets
 
4609
LB of Hackney
 
3788
Other values (146)
71292
ValueCountFrequency (%) 
City of Westminster 5583 6.5%
 
LB of Tower Hamlets 4609 5.4%
 
LB of Hackney 3788 4.4%
 
LB of Islington 3767 4.4%
 
LB of Camden 3096 3.6%
 
LB of Southwark 2562 3.0%
 
LB of Wandsworth 2556 3.0%
 
RB of Kensington and Chelsea 2516 3.0%
 
LB of Brent 2497 2.9%
 
LB of Lambeth 2455 2.9%
 
Other values (139) 51843 60.8%
 
Max length28
Mean length14.04978071
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

neighbourhood_cleansed
Categorical

Distinct count35
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Westminster
 
9809
Tower Hamlets
 
8198
Hackney
 
6240
Other values (31)
61026
ValueCountFrequency (%) 
Westminster 9809 11.5%
 
Tower Hamlets 8198 9.6%
 
Hackney 6240 7.3%
 
Kensington and Chelsea 6023 7.1%
 
Camden 5962 7.0%
 
Islington 5131 6.0%
 
Southwark 4888 5.7%
 
Lambeth 4856 5.7%
 
Wandsworth 4353 5.1%
 
Hammersmith and Fulham 4190 4.9%
 
Other values (24) 25623 30.0%
 
Max length22
Mean length10.62493843
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

number_of_reviews
Numeric

Distinct count412
Unique (%)0.5%
Missing (%)< 0.1%
Missing (n)2
Infinite (%)0.0%
Infinite (n)0
Mean16.81730228
Minimum0
Maximum690
Zeros (%)24.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median4
Q317
95-th percentile77
Maximum690
Range690
Interquartile range16

Descriptive statistics

Standard deviation35.67412186
Coef of variation2.121274939
Kurtosis38.66970663
Mean16.81730228
MAD19.77222867
Skewness5.033409711
Sum1434045
Variance1272.642971
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 21003 24.6%
 
1 9291 10.9%
 
2 5929 7.0%
 
3 4538 5.3%
 
4 3622 4.2%
 
5 2873 3.4%
 
6 2480 2.9%
 
7 2087 2.4%
 
8 1914 2.2%
 
9 1698 2.0%
 
Other values (401) 29837 35.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 21003 24.6%
 
1 9291 10.9%
 
2 5929 7.0%
 
3 4538 5.3%
 
4 3622 4.2%
 

Maximum 5 values

ValueCountFrequency (%) 
690 1 < 0.1%
 
633 1 < 0.1%
 
612 1 < 0.1%
 
595 1 < 0.1%
 
591 1 < 0.1%
 

number_of_reviews_ltm
Numeric

Distinct count147
Unique (%)0.2%
Missing (%)< 0.1%
Missing (n)2
Infinite (%)0.0%
Infinite (n)0
Mean6.613519092
Minimum0
Maximum231
Zeros (%)41.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q38
95-th percentile31
Maximum231
Range231
Interquartile range8

Descriptive statistics

Standard deviation12.70142361
Coef of variation1.920524222
Kurtosis20.65124055
Mean6.613519092
MAD7.886865158
Skewness3.753960323
Sum563948
Variance161.3261617
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 35468 41.6%
 
1 8370 9.8%
 
2 5441 6.4%
 
3 4130 4.8%
 
4 3380 4.0%
 
5 2745 3.2%
 
6 2318 2.7%
 
7 2023 2.4%
 
8 1737 2.0%
 
9 1584 1.9%
 
Other values (136) 18076 21.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 35468 41.6%
 
1 8370 9.8%
 
2 5441 6.4%
 
3 4130 4.8%
 
4 3380 4.0%
 

Maximum 5 values

ValueCountFrequency (%) 
231 1 < 0.1%
 
200 1 < 0.1%
 
185 1 < 0.1%
 
182 1 < 0.1%
 
180 1 < 0.1%
 

price
Categorical

Distinct count889
Unique (%)1.0%
Missing (%)< 0.1%
Missing (n)1
$50.00
 
3107
$100.00
 
3066
$40.00
 
2796
Other values (885)
76304
ValueCountFrequency (%) 
$50.00 3107 3.6%
 
$100.00 3066 3.6%
 
$40.00 2796 3.3%
 
$35.00 2531 3.0%
 
$30.00 2365 2.8%
 
$120.00 2360 2.8%
 
$45.00 2303 2.7%
 
$150.00 2280 2.7%
 
$60.00 2245 2.6%
 
$80.00 2226 2.6%
 
Other values (878) 59994 70.4%
 
Max length10
Mean length6.420608861
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

property_type
Categorical

Distinct count45
Unique (%)0.1%
Missing (%)< 0.1%
Missing (n)1
Apartment
56401
House
17952
Townhouse
 
2995
Other values (41)
 
7925
ValueCountFrequency (%) 
Apartment 56401 66.1%
 
House 17952 21.1%
 
Townhouse 2995 3.5%
 
Condominium 2716 3.2%
 
Serviced apartment 1719 2.0%
 
Loft 739 0.9%
 
Bed and breakfast 647 0.8%
 
Guest suite 364 0.4%
 
Guesthouse 305 0.4%
 
Boutique hotel 242 0.3%
 
Other values (34) 1193 1.4%
 
Max length29
Mean length8.412646293
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

require_guest_phone_verification
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)2
f
83843
t
 
1429
(Missing)
 
2
ValueCountFrequency (%) 
f 83843 98.3%
 
t 1429 1.7%
 
(Missing) 2 < 0.1%
 

require_guest_profile_picture
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)2
f
84413
t
 
859
(Missing)
 
2
ValueCountFrequency (%) 
f 84413 99.0%
 
t 859 1.0%
 
(Missing) 2 < 0.1%
 

requires_license
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)2
f
85269
t
 
3
(Missing)
 
2
ValueCountFrequency (%) 
f 85269 > 99.9%
 
t 3 < 0.1%
 
(Missing) 2 < 0.1%
 

review_scores_accuracy
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.7%
Missing (n)22735
Infinite (%)0.0%
Infinite (n)0
Mean9.500311805
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation0.9994301354
Coef of variation0.1051997193
Kurtosis19.01700441
Mean9.500311805
MAD0.6788645128
Skewness-3.648096413
Sum594140
Variance0.9988605955
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 42482 49.8%
 
9 14163 16.6%
 
8 3716 4.4%
 
7 802 0.9%
 
6 761 0.9%
 
2 305 0.4%
 
4 189 0.2%
 
5 108 0.1%
 
3 13 < 0.1%
 
(Missing) 22735 26.7%
 

Minimum 5 values

ValueCountFrequency (%) 
2 305 0.4%
 
3 13 < 0.1%
 
4 189 0.2%
 
5 108 0.1%
 
6 761 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
10 42482 49.8%
 
9 14163 16.6%
 
8 3716 4.4%
 
7 802 0.9%
 
6 761 0.9%
 

review_scores_checkin
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.7%
Missing (n)22783
Infinite (%)0.0%
Infinite (n)0
Mean9.624041862
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q110
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.9068226974
Coef of variation0.09422472495
Kurtosis26.23327385
Mean9.624041862
MAD0.5711897319
Skewness-4.336635281
Sum601416
Variance0.8223274045
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 47471 55.7%
 
9 10728 12.6%
 
8 2616 3.1%
 
7 616 0.7%
 
6 570 0.7%
 
2 263 0.3%
 
4 147 0.2%
 
5 70 0.1%
 
3 10 < 0.1%
 
(Missing) 22783 26.7%
 

Minimum 5 values

ValueCountFrequency (%) 
2 263 0.3%
 
3 10 < 0.1%
 
4 147 0.2%
 
5 70 0.1%
 
6 570 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
10 47471 55.7%
 
9 10728 12.6%
 
8 2616 3.1%
 
7 616 0.7%
 
6 570 0.7%
 

review_scores_cleanliness
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.6%
Missing (n)22722
Infinite (%)0.0%
Infinite (n)0
Mean9.261494437
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile7
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation1.149805624
Coef of variation0.1241490379
Kurtosis10.79236777
Mean9.261494437
MAD0.8176075469
Skewness-2.714264208
Sum579325
Variance1.322052973
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 34626 40.6%
 
9 17642 20.7%
 
8 6598 7.7%
 
7 1669 2.0%
 
6 1138 1.3%
 
2 349 0.4%
 
4 310 0.4%
 
5 197 0.2%
 
3 23 < 0.1%
 
(Missing) 22722 26.6%
 

Minimum 5 values

ValueCountFrequency (%) 
2 349 0.4%
 
3 23 < 0.1%
 
4 310 0.4%
 
5 197 0.2%
 
6 1138 1.3%
 

Maximum 5 values

ValueCountFrequency (%) 
10 34626 40.6%
 
9 17642 20.7%
 
8 6598 7.7%
 
7 1669 2.0%
 
6 1138 1.3%
 

review_scores_communication
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.7%
Missing (n)22728
Infinite (%)0.0%
Infinite (n)0
Mean9.64827487
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q110
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.9056841568
Coef of variation0.09387006164
Kurtosis27.68830452
Mean9.64827487
MAD0.5499522087
Skewness-4.519780247
Sum603461
Variance0.8202637918
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 48898 57.3%
 
9 9561 11.2%
 
8 2414 2.8%
 
7 588 0.7%
 
6 568 0.7%
 
2 269 0.3%
 
4 156 0.2%
 
5 79 0.1%
 
3 13 < 0.1%
 
(Missing) 22728 26.7%
 

Minimum 5 values

ValueCountFrequency (%) 
2 269 0.3%
 
3 13 < 0.1%
 
4 156 0.2%
 
5 79 0.1%
 
6 568 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
10 48898 57.3%
 
9 9561 11.2%
 
8 2414 2.8%
 
7 588 0.7%
 
6 568 0.7%
 

review_scores_location
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.7%
Missing (n)22782
Infinite (%)0.0%
Infinite (n)0
Mean9.526899443
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation0.830363656
Coef of variation0.08715990558
Kurtosis19.62898166
Mean9.526899443
MAD0.6150791756
Skewness-3.34135892
Sum595355
Variance0.6895038011
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 40623 47.6%
 
9 16972 19.9%
 
8 3649 4.3%
 
6 526 0.6%
 
7 466 0.5%
 
2 142 0.2%
 
4 85 0.1%
 
5 28 < 0.1%
 
3 1 < 0.1%
 
(Missing) 22782 26.7%
 

Minimum 5 values

ValueCountFrequency (%) 
2 142 0.2%
 
3 1 < 0.1%
 
4 85 0.1%
 
5 28 < 0.1%
 
6 526 0.6%
 

Maximum 5 values

ValueCountFrequency (%) 
10 40623 47.6%
 
9 16972 19.9%
 
8 3649 4.3%
 
7 466 0.5%
 
6 526 0.6%
 

review_scores_rating
Numeric

Distinct count62
Unique (%)0.1%
Missing (%)26.6%
Missing (n)22684
Infinite (%)0.0%
Infinite (n)0
Mean92.51442722
Minimum20
Maximum100
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20
5-th percentile76
Q190
Median96
Q3100
95-th percentile100
Maximum100
Range80
Interquartile range10

Descriptive statistics

Standard deviation10.25770956
Coef of variation0.1108768639
Kurtosis14.52539377
Mean92.51442722
MAD6.857333534
Skewness-3.098447603
Sum5790478
Variance105.2206054
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
100 17907 21.0%
 
98 3877 4.5%
 
97 3731 4.4%
 
96 3640 4.3%
 
93 3623 4.2%
 
90 3364 3.9%
 
95 3343 3.9%
 
80 3303 3.9%
 
99 2505 2.9%
 
94 2390 2.8%
 
Other values (51) 14907 17.5%
 
(Missing) 22684 26.6%
 

Minimum 5 values

ValueCountFrequency (%) 
20 295 0.3%
 
30 9 < 0.1%
 
32 1 < 0.1%
 
33 1 < 0.1%
 
40 223 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
100 17907 21.0%
 
99 2505 2.9%
 
98 3877 4.5%
 
97 3731 4.4%
 
96 3640 4.3%
 

review_scores_value
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.7%
Missing (n)22783
Infinite (%)0.0%
Infinite (n)0
Mean9.26541422
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation1.04789939
Coef of variation0.1130979538
Kurtosis13.0989518
Mean9.26541422
MAD0.7395581729
Skewness-2.846842154
Sum579005
Variance1.098093131
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 31457 36.9%
 
9 22279 26.1%
 
8 6050 7.1%
 
7 1101 1.3%
 
6 929 1.1%
 
2 288 0.3%
 
4 234 0.3%
 
5 136 0.2%
 
3 17 < 0.1%
 
(Missing) 22783 26.7%
 

Minimum 5 values

ValueCountFrequency (%) 
2 288 0.3%
 
3 17 < 0.1%
 
4 234 0.3%
 
5 136 0.2%
 
6 929 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
10 31457 36.9%
 
9 22279 26.1%
 
8 6050 7.1%
 
7 1101 1.3%
 
6 929 1.1%
 

reviews_per_month
Numeric

Distinct count932
Unique (%)1.1%
Missing (%)24.6%
Missing (n)21005
Infinite (%)0.0%
Infinite (n)0
Mean1.178750253
Minimum0.01
Maximum48.21
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.01
5-th percentile0.05
Q10.24
Median0.74
Q31.6
95-th percentile3.94
Maximum48.21
Range48.2
Interquartile range1.36

Descriptive statistics

Standard deviation1.375763779
Coef of variation1.167137632
Kurtosis30.11427919
Mean1.178750253
MAD0.9649094663
Skewness2.981539061
Sum75757.1
Variance1.892725976
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 1889 2.2%
 
0.04 1066 1.3%
 
0.08 1022 1.2%
 
0.05 954 1.1%
 
0.07 923 1.1%
 
0.02 921 1.1%
 
0.03 896 1.1%
 
0.12 803 0.9%
 
0.06 800 0.9%
 
0.1 714 0.8%
 
Other values (921) 54281 63.7%
 
(Missing) 21005 24.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0.01 34 < 0.1%
 
0.02 921 1.1%
 
0.03 896 1.1%
 
0.04 1066 1.3%
 
0.05 954 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
48.21 1 < 0.1%
 
24.39 1 < 0.1%
 
15.52 1 < 0.1%
 
15.17 1 < 0.1%
 
14.72 1 < 0.1%
 

room_type
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Entire home/apt
47115
Private room
36013
Hotel room
 
1510
Other values (2)
 
635
ValueCountFrequency (%) 
Entire home/apt 47115 55.3%
 
Private room 36013 42.2%
 
Hotel room 1510 1.8%
 
Shared room 634 0.7%
 
t 1 < 0.1%
 
(Missing) 1 < 0.1%
 
Max length15
Mean length13.61445458
Min length1
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

security_deposit
Categorical

Distinct count381
Unique (%)0.4%
Missing (%)34.8%
Missing (n)29653
$0.00
19620
$100.00
6014
$200.00
 
4997
Other values (377)
24990
(Missing)
29653
ValueCountFrequency (%) 
$0.00 19620 23.0%
 
$100.00 6014 7.1%
 
$200.00 4997 5.9%
 
$250.00 3644 4.3%
 
$300.00 3322 3.9%
 
$500.00 3283 3.8%
 
$150.00 2904 3.4%
 
$85.00 1958 2.3%
 
$495.00 1324 1.6%
 
$350.00 1017 1.2%
 
Other values (370) 7538 8.8%
 
(Missing) 29653 34.8%
 
Max length10
Mean length5.137967024
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Correlations

Missing values

Sample

First rows

accommodatesamenitiesavailability_365bathroomsbed_typebedroomsbedscalculated_host_listings_countcancellation_policycitycleaning_feeexperiences_offeredextra_peoplefirst_reviewguests_includedhost_has_profile_pichost_identity_verifiedhost_is_superhosthost_neighbourhoodhost_response_ratehost_sincehost_total_listings_counthost_verificationsinstant_bookableis_business_travel_readyis_location_exactlast_reviewlatitudelongitudemaximum_nightsmaximum_nights_avg_ntmminimum_nightsminimum_nights_avg_ntmneighbourhoodneighbourhood_cleansednumber_of_reviewsnumber_of_reviews_ltmpriceproperty_typerequire_guest_phone_verificationrequire_guest_profile_picturerequires_licensereview_scores_accuracyreview_scores_checkinreview_scores_cleanlinessreview_scores_communicationreview_scores_locationreview_scores_ratingreview_scores_valuereviews_per_monthroom_typesecurity_deposit
04.0{TV,"Cable TV",Internet,Wifi,Kitchen,"Paid parking off premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Pack ’n Play/travel crib","Hot water","Long term stays allowed"}344.01.0Real Bed1.01.02.0strict_14_with_grace_periodLondon$30.00family$20.002010-03-212.0tttBrixton100%2009-10-033.0['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id']tft2019-07-1051.46225-0.11732180.0180.02.02.0BrixtonLambeth184.01.0$88.00Apartmenttff9.010.09.010.09.092.09.01.59Entire home/apt$400.00
12.0{TV,"Cable TV",Wifi,Kitchen,"Paid parking off premises","Smoking allowed","Free street parking","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"Children’s books and toys","Babysitter recommendations",Crib,"Pack ’n Play/travel crib","Room-darkening shades","Children’s dinnerware","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection","Coffee maker",Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Patio or balcony","Luggage dropoff allowed","Long term stays allowed","No stairs or steps to enter","Wide entrance","Extra space around bed","Accessible-height bed","No stairs or steps to enter","Wide doorway to guest bathroom","Bathtub with bath chair","Accessible-height toilet","Host greets you","Handheld shower head","Roll-in shower"}353.01.0Real Bed1.00.03.0moderateIslington$15.00business$15.002010-08-181.0tffLB of Islington100%2009-11-164.0['email', 'phone', 'facebook', 'reviews']fft2019-06-1051.56802-0.1112129.029.01.01.0LB of IslingtonIslington16.02.0$65.00Apartmentfff9.09.010.010.09.096.09.00.14Private room$100.00
22.0{TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water",Microwave,"Coffee maker","Dishes and silverware","Luggage dropoff allowed","Long term stays allowed",Other}114.01.0Real Bed1.01.01.0strict_14_with_grace_periodLondon$50.00romantic$0.002009-12-212.0tttChelsea100%2009-12-051.0['email', 'phone', 'reviews', 'jumio', 'government_id']tft2019-08-2751.48796-0.1689850.050.030.030.0ChelseaKensington and Chelsea87.06.0$100.00Apartmentttf10.010.010.010.010.096.09.00.73Entire home/apt$150.00
36.0{TV,Wifi,Kitchen,"Paid parking off premises",Elevator,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Hot water","Bed linens",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed"}265.02.0Real Bed3.04.015.0strict_14_with_grace_periodLondon$65.00none$10.002011-03-214.0tttFitzrovia98%2010-01-0418.0['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual', 'work_email']tft2019-06-1951.52098-0.14002365.0365.03.03.0City of WestminsterWestminster41.05.0$300.00Apartmentfff10.09.09.09.010.094.09.00.40Entire home/apt$350.00
42.0{TV,"Cable TV",Internet,Wifi,Kitchen,"Free parking on premises","Pets allowed","Pets live on this property","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Hot water","Long term stays allowed"}346.01.5Real Bed1.01.01.0moderateLondon$70.00family$0.002010-11-152.0ttfBattersea80%2009-09-280.0['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id']fft2019-06-0851.47298-0.163761125.01125.030.030.0LB of WandsworthWandsworth93.01.0$175.00Townhousettf10.010.010.010.09.098.09.00.86Entire home/apt$250.00
54.0{TV,Wifi,Kitchen,"Free parking on premises",Elevator,"Buzzer/wireless intercom",Heating,Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water","Host greets you"}147.01.0Real Bed2.02.01.0moderateWimbledon$50.00none$11.002016-03-052.0tffWimbledon100%2010-04-031.0['email', 'phone', 'reviews']tft2019-07-2551.44687-0.218741125.01125.090.090.0LB of WandsworthWandsworth31.05.0$65.00Apartmentfff10.09.09.010.09.092.09.00.72Entire home/apt$250.00
62.0{Wifi,Kitchen,"Buzzer/wireless intercom",Heating,Washer,"Smoke detector",Essentials,Shampoo,"Lock on bedroom door","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}288.01.5Real Bed1.01.03.0strict_14_with_grace_periodBarnet$0.00none$8.002010-04-141.0tftLB of Barnet100%2010-04-053.0['email', 'phone', 'reviews', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']tft2019-06-2851.57224-0.209061120.01120.010.010.0LB of BarnetBarnet122.05.0$29.00Housefff10.010.010.010.09.095.010.01.06Private room$100.00
74.0{TV,"Cable TV",Internet,Wifi,Kitchen,"Paid parking off premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"High chair","Children’s books and toys",Crib,"Pack ’n Play/travel crib","Children’s dinnerware","Hot water","Bed linens","Extra pillows and blankets","Coffee maker",Refrigerator,"Luggage dropoff allowed","Long term stays allowed","Host greets you"}339.01.0Real Bed1.03.03.0strict_14_with_grace_periodIslington$75.00none$15.002010-11-023.0ttfCanonbury100%2010-04-193.0['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']tft2019-07-2251.54168-0.10207365.0365.03.02.9LB of IslingtonIslington63.09.0$147.00Apartmentfff8.09.09.09.09.085.08.00.58Entire home/apt$100.00
82.0{TV,Wifi,Kitchen,"Paid parking off premises",Breakfast,Heating,Washer,"Smoke detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"translation missing: en.hosting_amenity_50","Hot water",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Garden or backyard","Host greets you"}336.01.5Real Bed1.01.02.0strict_14_with_grace_periodLondon$10.00none$12.002010-07-011.0tttLB of Newham100%2010-05-292.0['email', 'phone', 'facebook', 'reviews', 'jumio', 'offline_government_id', 'government_id']fft2019-06-3051.534840.0270730.030.01.01.0LB of NewhamNewham115.010.0$34.00Townhousettf10.010.010.010.09.097.010.01.03Private roomNaN
92.0{Wifi,Kitchen,"Pets live on this property",Cat(s),"Free street parking",Heating,Washer,Dryer,"Smoke detector",Essentials,"Self check-in","Building staff","Hot water"}365.01.0Real Bed1.01.01.0flexibleTwickenhamNaNnone$0.002010-10-161.0ttfLB of Hounslow100%2010-06-141.0['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id']fft2019-05-2651.46507-0.3242121.021.01.01.0LB of HounslowHounslow5.02.0$100.00Housefff9.010.010.010.010.088.08.00.05Private roomNaN

Last rows

accommodatesamenitiesavailability_365bathroomsbed_typebedroomsbedscalculated_host_listings_countcancellation_policycitycleaning_feeexperiences_offeredextra_peoplefirst_reviewguests_includedhost_has_profile_pichost_identity_verifiedhost_is_superhosthost_neighbourhoodhost_response_ratehost_sincehost_total_listings_counthost_verificationsinstant_bookableis_business_travel_readyis_location_exactlast_reviewlatitudelongitudemaximum_nightsmaximum_nights_avg_ntmminimum_nightsminimum_nights_avg_ntmneighbourhoodneighbourhood_cleansednumber_of_reviewsnumber_of_reviews_ltmpriceproperty_typerequire_guest_phone_verificationrequire_guest_profile_picturerequires_licensereview_scores_accuracyreview_scores_checkinreview_scores_cleanlinessreview_scores_communicationreview_scores_locationreview_scores_ratingreview_scores_valuereviews_per_monthroom_typesecurity_deposit
852641.0{TV,Wifi,"Air conditioning",Kitchen,"Pets allowed",Heating,"Smoke detector",Essentials,"Hair dryer",Iron}173.01.0Real Bed1.01.01.0flexibleGreater LondonNaNnone$0.00NaN1.0tffNaNNaN2019-09-141['phone']tffNaN51.561630.073091125.011251.01LB of RedbridgeRedbridge0.00.0$101.00HousefffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/aptNaN
852654.0{TV,Wifi,Kitchen,"Free parking on premises","Pets allowed",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Private entrance","Hot water"}307.01.0Real Bed2.02.01.0flexibleTeddingtonNaNnone$0.00NaN1.0tffNaNNaN2016-06-121['email', 'phone', 'facebook', 'reviews']tffNaN51.42155-0.314521125.011252.02LB of Richmond upon ThamesRichmond upon Thames0.00.0$105.00HousefffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/aptNaN
852662.0{TV,Wifi,Kitchen,"Free parking on premises",Heating,Washer,"Smoke detector","First aid kit","Fire extinguisher",Essentials,Hangers,Iron,"Laptop friendly workspace","Private entrance","Hot water"}80.01.0Real Bed1.02.01.0flexibleLondonNaNnone$0.00NaN1.0tffNaNNaN2015-07-161['email', 'phone', 'reviews']tffNaN51.42874-0.047861125.011251.01SydenhamLewisham0.00.0$78.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/aptNaN
852672.0{Wifi,Kitchen,"Free parking on premises","Pets allowed",Breakfast,Heating,Washer,Essentials,Shampoo,Hangers,"Laptop friendly workspace","Private entrance","Dishes and silverware"}73.01.0Real Bed1.01.01.0strict_14_with_grace_periodGreater London$0.00none$0.00NaN1.0tffLB of EnfieldNaN2019-05-050['email', 'phone']tftNaN51.62711-0.125021125.011252.02LB of EnfieldEnfield0.00.0$30.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt$100.00
852682.0{Wifi,Kitchen,Washer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}30.01.0Real Bed2.02.01.0flexibleGreater LondonNaNnone$0.00NaN1.0tffNotting HillNaN2012-09-070['phone', 'reviews', 'jumio', 'government_id']tffNaN51.51357-0.205631125.011256.06Notting HillKensington and Chelsea0.00.0$56.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNPrivate roomNaN
852695.0{TV,Wifi,Kitchen,"Free parking on premises",Heating,Washer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer",Iron}45.01.5Real Bed1.03.07.0flexibleGreater London$40.00none$0.00NaN1.0tffBattersea95%2018-07-273['email', 'phone', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']tffNaN51.51383-0.272881125.011252.02LB of EalingEaling0.00.0$85.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt$0.00
852702.0{Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer","Laptop friendly workspace","Self check-in",Lockbox,"Hot water"}2.02.0Real Bed1.01.02.0flexibleGreater LondonNaNnone$0.00NaN1.0tffCricklewood90%2017-09-122['email', 'phone', 'jumio', 'offline_government_id', 'government_id']fffNaN51.55569-0.212511125.011251.01HampsteadCamden0.00.0$35.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNPrivate roomNaN
852716.0{TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises",Breakfast,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance"}173.04.0Real Bed3.03.01.0flexibleGreater LondonNaNnone$0.00NaN1.0tffWestminsterNaN2019-09-140['email', 'phone', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']fftNaN51.49741-0.139011125.011257.07WestminsterWestminster0.00.0$420.00CondominiumfffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/aptNaN
852722.0{Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed",Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}233.01.0Real Bed1.01.01.0flexibleGreater LondonNaNnone$0.00NaN1.0tffLB of HillingdonNaN2019-09-140['email', 'phone']fftNaN51.54849-0.4550415.0151.01LB of HillingdonHillingdon0.00.0$35.00HousefffNaNNaNNaNNaNNaNNaNNaNNaNPrivate room$81.00
852735.0{TV,Wifi,Kitchen,Breakfast,Heating,Washer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo}32.01.0Real Bed2.02.03.0flexibleGreater LondonNaNnone$0.00NaN1.0ttfBrixton100%2013-05-032['email', 'phone', 'google', 'reviews', 'jumio', 'government_id']fftNaN51.42159-0.131397.072.02Lower StreathamLambeth0.00.0$50.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/aptNaN